﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/



USE [$(DatabaseName)];

TRUNCATE TABLE [dbo].[Configuration];

INSERT INTO [dbo].[Configuration]
	VALUES ('wsdlBasePath', 'http://localhost/HomeFramework/HomeFrameworkService.svc');

INSERT INTO [dbo].[Configuration]
	VALUES ('cacheTimeoutMinutes', '1');

INSERT INTO [dbo].[Configuration]
	VALUES ('innerServicePath', 'net.pipe://localhost/HomeFramework/InnerService.svc');

INSERT INTO Handlers
SELECT
  'IEchoService',
  1,
  'DemoEchoService',
  'DemoEchoService.EchoService',
  'DemoEchoService.IEchoService',
  'DemoEchoService, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null',
  convert(varbinary(max),'TVqQAAMAAAAEAAAA//8AALgAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAA4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1vZGUuDQ0KJAAAAAAAAABQRQAATAEDAInuZE0AAAAAAAAAAOAAAiELAQgAAAoAAAAGAAAAAAAAXigAAAAgAAAAQAAAAABAAAAgAAAAAgAABAAAAAAAAAAEAAAAAAAAAACAAAAAAgAAAAAAAAMAQIUAABAAABAAAAAAEAAAEAAAAAAAABAAAAAAAAAAAAAAABAoAABLAAAAAEAAAIADAAAAAAAAAAAAAAAAAAAAAAAAAGAAAAwAAABgJwAAHAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAACAAAAAAAAAAAAAAACCAAAEgAAAAAAAAAAAAAAC50ZXh0AAAAZAgAAAAgAAAACgAAAAIAAAAAAAAAAAAAAAAAACAAAGAucnNyYwAAAIADAAAAQAAAAAQAAAAMAAAAAAAAAAAAAAAAAABAAABALnJlbG9jAAAMAAAAAGAAAAACAAAAEAAAAAAAAAAAAAAAAAAAQAAAQgAAAAAAAAAAAAAAAAAAAABAKAAAAAAAAEgAAAACAAUAcCAAAPAGAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABMwAQAMAAAAAQAAEQADbxMAAAoKKwAGKh4CKBQAAAoqQlNKQgEAAQAAAAAADAAAAHY0LjAuMzAzMTkAAAAABQBsAAAATAIAACN+AAC4AgAA8AIAACNTdHJpbmdzAAAAAKgFAAAIAAAAI1VTALAFAAAQAAAAI0dVSUQAAADABQAAMAEAACNCbG9iAAAAAAAAAAIAAAFHFwIACQAAAAD6JTMAFgAAAQAAABUAAAADAAAAAwAAAAIAAAABAAAAFAAAABAAAAABAAAAAQAAAAIAAAAAAAoAAQAAAAAABgBXAFAABgCNAHMABgC4AKYABgDPAKYABgDsAKYABgALAaYABgAkAaYABgA9AaYABgBYAaYABgBzAaYABgCrAYwBBgC/AYwBBgDNAaYABgDmAaYABgAWAgMCPwAqAgAABgBZAjkCBgB5AjkCCgCrApcCCgDEApcCBgDfAlAAAAAAAAEAAAAAAAEAAQChAAAAHgArAAAAAQABAAEAEAA7ACsABQABAAIAAAAAAAAAxgVeAAoAAQBQIAAAAADmAV4ACgACAGggAAAAAIYYaQAPAAMAAAABAG8AAAABAG8AAwAIABEAaQATABkAaQATACEAaQATACkAaQATADEAaQATADkAaQATAEEAaQATAEkAaQATAFEAaQATAFkAaQAYAGEAaQATAGkAaQATAHEAaQATAHkAaQAdAIkAaQAjAJEAaQAPAJkAaQAPAKEAaQAPAKkA5gItAAkAaQAPACAAkwAoAC4AMwB9AC4ACwA1AC4AEwB9AC4AGwCSAC4AIwCSAC4AKwCYAC4AWwDIAC4AgwARAS4AQwCSAC4AUwCSAC4AOwCnAC4AawDyAC4AcwD/AC4AewAIAUMAiwAoADEABIAAAAEAAAAAAAAAAAAAAAAAKwAAAAQAAAAAAAAAAAAAAAEARwAAAAAABAAAAAAAAAAAAAAAAQCXAgAAAAAAAAAAADxNb2R1bGU+AERlbW9FY2hvU2VydmljZS5kbGwASUVjaG9TZXJ2aWNlAERlbW9FY2hvU2VydmljZQBFY2hvU2VydmljZQBtc2NvcmxpYgBTeXN0ZW0AT2JqZWN0AEVjaG9TdHJpbmcALmN0b3IAYXJnAFN5c3RlbS5SdW50aW1lLlZlcnNpb25pbmcAVGFyZ2V0RnJhbWV3b3JrQXR0cmlidXRlAFN5c3RlbS5SZWZsZWN0aW9uAEFzc2VtYmx5VGl0bGVBdHRyaWJ1dGUAQXNzZW1ibHlEZXNjcmlwdGlvbkF0dHJpYnV0ZQBBc3NlbWJseUNvbmZpZ3VyYXRpb25BdHRyaWJ1dGUAQXNzZW1ibHlDb21wYW55QXR0cmlidXRlAEFzc2VtYmx5UHJvZHVjdEF0dHJpYnV0ZQBBc3NlbWJseUNvcHlyaWdodEF0dHJpYnV0ZQBBc3NlbWJseVRyYWRlbWFya0F0dHJpYnV0ZQBBc3NlbWJseUN1bHR1cmVBdHRyaWJ1dGUAU3lzdGVtLlJ1bnRpbWUuSW50ZXJvcFNlcnZpY2VzAENvbVZpc2libGVBdHRyaWJ1dGUAR3VpZEF0dHJpYnV0ZQBBc3NlbWJseVZlcnNpb25BdHRyaWJ1dGUAQXNzZW1ibHlGaWxlVmVyc2lvbkF0dHJpYnV0ZQBTeXN0ZW0uRGlhZ25vc3RpY3MARGVidWdnYWJsZUF0dHJpYnV0ZQBEZWJ1Z2dpbmdNb2RlcwBTeXN0ZW0uUnVudGltZS5Db21waWxlclNlcnZpY2VzAENvbXBpbGF0aW9uUmVsYXhhdGlvbnNBdHRyaWJ1dGUAUnVudGltZUNvbXBhdGliaWxpdHlBdHRyaWJ1dGUAU3lzdGVtLlNlcnZpY2VNb2RlbABTZXJ2aWNlQ29udHJhY3RBdHRyaWJ1dGUAT3BlcmF0aW9uQ29udHJhY3RBdHRyaWJ1dGUAU3RyaW5nAFRvVXBwZXIAAAAAAyAAAAAAAGaw4GDVtmBGp4c71UUcjd4ACLd6XFYZNOCJBCABDg4DIAABBCABAQ4EIAEBAgUgAQERQQQgAQEIBAEAAAADIAAOAwcBDkcBABouTkVURnJhbWV3b3JrLFZlcnNpb249djQuMAEAVA4URnJhbWV3b3JrRGlzcGxheU5hbWUQLk5FVCBGcmFtZXdvcmsgNBQBAA9EZW1vRWNob1NlcnZpY2UAAAUBAAAAAA4BAAlNaWNyb3NvZnQAACABABtDb3B5cmlnaHQgwqkgTWljcm9zb2Z0IDIwMTEAACkBACQzNzdiZDg2My1hZGRiLTQ0N2ItOWYyMS1kYTI2YjBmNDFiYTQAAAwBAAcxLjAuMC4wAAAIAQAHAQAAAAAIAQAIAAAAAAAeAQABAFQCFldyYXBOb25FeGNlcHRpb25UaHJvd3MBAAAAAInuZE0AAAAAAgAAAJMAAAB8JwAAfAkAAFJTRFPldUdijYZvTKV1/ZTLmw2yAQAAAGM6XHVzZXJzXGFkbWluaXN0cmF0b3JcZG9jdW1lbnRzXHZpc3VhbCBzdHVkaW8gMjAxMFxQcm9qZWN0c1xEZW1vRWNob1NlcnZpY2VcRGVtb0VjaG9TZXJ2aWNlXG9ialxEZWJ1Z1xEZW1vRWNob1NlcnZpY2UucGRiAAA4KAAAAAAAAAAAAABOKAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQCgAAAAAAAAAAF9Db3JEbGxNYWluAG1zY29yZWUuZGxsAAAAAAD/JQAgQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABABAAAAAYAACAAAAAAAAAAAAAAAAAAAABAAEAAAAwAACAAAAAAAAAAAAAAAAAAAABAAAAAABIAAAAWEAAACgDAAAAAAAAAAAAACgDNAAAAFYAUwBfAFYARQBSAFMASQBPAE4AXwBJAE4ARgBPAAAAAAC9BO/+AAABAAAAAQAAAAAAAAABAAAAAAA/AAAAAAAAAAQAAAACAAAAAAAAAAAAAAAAAAAARAAAAAEAVgBhAHIARgBpAGwAZQBJAG4AZgBvAAAAAAAkAAQAAABUAHIAYQBuAHMAbABhAHQAaQBvAG4AAAAAAAAAsASIAgAAAQBTAHQAcgBpAG4AZwBGAGkAbABlAEkAbgBmAG8AAABkAgAAAQAwADAAMAAwADAANABiADAAAAA0AAoAAQBDAG8AbQBwAGEAbgB5AE4AYQBtAGUAAAAAAE0AaQBjAHIAbwBzAG8AZgB0AAAASAAQAAEARgBpAGwAZQBEAGUAcwBjAHIAaQBwAHQAaQBvAG4AAAAAAEQAZQBtAG8ARQBjAGgAbwBTAGUAcgB2AGkAYwBlAAAAMAAIAAEARgBpAGwAZQBWAGUAcgBzAGkAbwBuAAAAAAAxAC4AMAAuADAALgAwAAAASAAUAAEASQBuAHQAZQByAG4AYQBsAE4AYQBtAGUAAABEAGUAbQBvAEUAYwBoAG8AUwBlAHIAdgBpAGMAZQAuAGQAbABsAAAAXAAbAAEATABlAGcAYQBsAEMAbwBwAHkAcgBpAGcAaAB0AAAAQwBvAHAAeQByAGkAZwBoAHQAIACpACAATQBpAGMAcgBvAHMAbwBmAHQAIAAyADAAMQAxAAAAAABQABQAAQBPAHIAaQBnAGkAbgBhAGwARgBpAGwAZQBuAGEAbQBlAAAARABlAG0AbwBFAGMAaABvAFMAZQByAHYAaQBjAGUALgBkAGwAbAAAAEAAEAABAFAAcgBvAGQAdQBjAHQATgBhAG0AZQAAAAAARABlAG0AbwBFAGMAaABvAFMAZQByAHYAaQBjAGUAAAA0AAgAAQBQAHIAbwBkAHUAYwB0AFYAZQByAHMAaQBvAG4AAAAxAC4AMAAuADAALgAwAAAAOAAIAAEAQQBzAHMAZQBtAGIAbAB5ACAAVgBlAHIAcwBpAG8AbgAAADEALgAwAC4AMAAuADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAMAAAAYDgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),
  '1.0.0.0',
  null, 
  null;